package edu.whu.demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import edu.whu.demo.Vo.CommodityVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author guanruwang
 * @date 2023/10/24$
 */
@Mapper
public interface CommodityVoDao extends   BaseMapper<CommodityVo> {

    @Select("select * from commodity,commodity_supplier where commodity.id = #{commodityId} and commodity.id = commodity_supplier.commodity_id")
    CommodityVo getCommodityVosById(Integer commodityId);
}
